# sql集合
select_test = "select * from t"

# 查询棋谱库
select_go_data = "select sgf,black,white,blackRank,whiteRank,result,createTime,readTime,playDate,komi,platform,rule,hash from go_data"

# 带参数查询棋谱库
select_go_data_plus = "select sgf,black,white,blackRank,whiteRank,result,createTime,readTime,playDate,komi,platform,rule,hash from go_data {}"

insert_go_data = "insert into go_data (sgf,black,white,blackRank,whiteRank,result,createTime,readTime,playDate,komi,platform,rule,hash) " \
                 "values('{}','{}','{}','{}','{}','{}','{}','{}','{}','{}','{}','{}','{}') "

# 查询解析表

select_file_read = "select count(*) as count from file_read where filename = '{}'"

select_count_go_data = 'select count(1) as count from go_data'

# 插入解析表

insert_file_read = "insert into file_read (filename) values('{}')"

# 清理表
vacuum = 'vacuum'

delete_file_name = "delete from file_read"

delete_go_data = "delete from go_data"